Enhancements to AR Aging Forecast Details Report (Dynamic)

To ensure better visibility for financial analysis, the following enhancements have been made to the AR Aging Forecast Details report (Dynamic) to provide more clarity on the transactions performed in the A/R accounts and their balances.

  • The Unapplied column has been moved next to the Un-Invoiced column.

  • The Total column has been renamed as Total Balance.

  • When no values are available for the Un-Invoiced, Unapplied, and Total columns, a default value, 0, will be displayed.

  • The calculation of the total balance displayed in the Total Balance column has been modified as follows: Total Balance = (Invoiced + Un-Invoiced) - (Unapplied Payments).

  • A new mandatory single-select drop-down list, Property, has been added that displays all properties under the tenant. The current property will be displayed by default. Users can select the preferred property for report generation.

  • A new optional multi-select drop-down list, Options, has been added that displays the following options:

Field

Description

Include Unapplied in Aging Buckets

The unapplied payments will be subtracted from the oldest aging buckets. For example, if $250 is in the 61-90 bucket, $100 is in the 31-60 bucket, and the unapplied payment available in the account is $220, in this case, the unapplied payment will be subtracted from the 61-90 bucket ($250.00 -$220.00 = $30.00).

Include Uninvoiced in Aging Buckets

The un-invoiced amount will be added to the latest aging buckets. For example, if $250 is in the 61-90 bucket, $100 is in the 31-60 bucket, and the un-invoiced amount available in the account is $220, in this case, the un-invoiced amount will be added to the 31-60 bucket ($100.00 + $220.00 = $320.00).

Include Unapplied Accounts

Accounts with only unapplied payments and no invoiced/un-invoiced amounts for the selected date will be displayed.

Include Zero Balance Accounts

Accounts with zero invoice balance, zero un-invoiced amount, and zero unapplied payments will be displayed.

  • A new column, Charge Posted Date, has been added that displays the date when the charge was posted to the guest folio of a reservation. This date will continue to be displayed even when the charges are transferred to an A/R account.